EMT Practice Test

1. Question Content...

---

Question1: The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

Question2: True or False: Data Providers can share data with only the Data Consumer.

Question3: Which statement best describes Snowflake tables?

Question4: What is the most granular object that the Time Travel retention period can be defined on?
Select one.

Question5: As a best practice, clustering keys should only be defined on tables of which minimum size?

Question6: What are the three layers that make up Snowflake's architecture?
Choose 3 answer

Question7: Which of the following roles is recommended to be used to create and manage users and roles?

Question8: When scaling up Virtual Warehouse by increasing Virtual Warehouse t-shirt size, you are primarily scaling for improved:
Select one.

Question9: True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

Question10: If auto-suspend is enable for a Virtual Warehouse, he Warehouse is automatically suspended when:

Question11: When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:

Question12: Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

Question13: True or False: Snowflake charges a premium for storing semi-structured data.

Question14: What happens when a Data Provider revokes privileges to a Share on an object in their source database?

Question15: Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

Question16: True or False: You can define multiple columns within a clustering key on a table.

Question17: Which statements are true of micro-partitions?
Choose 2 answers

Question18: Which of the following statements is true of Snowflake?

Question19: Which of the following languages can be used to implement Snowflake User Defined Functions (UDFs)?
Choose 2 answers

Question20: What are the three things customers want most from their enterprise data warehouse solution?
Choose 3 answers

Question21: What privileges are required to create a task?

Question22: True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

Question23: Which of the following commands sets the Virtual Warehouse for a session?

Question24: True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

Question25: True or False: Snowflake's data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.

Question26: True or False the longer the data retention period, the higher the resulting storage costs.

Question27: Which of the following is true of Snowpipe via REST API?
Choose 2 answers

Question28: What privileges are required to execute a task?

Question29: Which object allows you to limit the number of credits consumed within a Snowflake account?
Select one.

Question30: How would you determine the size of the virtual warehouse used for a task?

Question31: What is the lowest Snowflake edition that offers Time Travel up to 90 days.

Question32: Which of the following statements is true of data loading?
Select one.

Question33: Which of the following statements are true of Snowflake data loading?
Choose 3 answers

Question34: True or False: When you create a custom role, it is a practice to immediately grant that role to ACCOUNTADMIN.

Question35: Which of the following are main sections of the top navigation of the Snowflake web Interface (UI)?

Question36: True or False: A Virtual Warehouse can be resized while suspended.

Question37: Which interfaces can be used to create and/or manage Virtual Warehouses?

Question38: Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers

Question39: True or False: Reader Accounts are able to extract data from shared data objects for use outside of Snowflake.

Question40: Which are true of Snowflake roles?

Question41: The FLATEEN function is used to query which type of data in Snowflake?

Question42: Which of the following accurately represents how a table fits into Snowflake's logical container hierarchy?
Select one.

Question43: True or False: When a user creates a role, they are initially assigned ownership of the role and they maintain ownership until it is transferred to another user.

Question44: True or False: The COPY command must specify a File Format in order to execute.

Question45: True or False: It is possible to unload structured data to semi-structured formats such as JSON and parquet.

Question46: True or False: All Snowflake table types include fail-safe storage.

Question47: Which of the following statements are true of Snowflake releases: (Choose two.)

Question48: Increasing the maximum number of clusters in a Multi-Cluster Warehouse is an example of:

Question49: Which of the following statements describes a benefit of Snowflake's separation of compute and storage?
(Choose all that apply.)

Question50: For a multi-cluster Warehouse, the number of credits billed is calculated on:
Select one.

Question51: What is the maximum compressed row size in Snowflake?

Question52: The number of queries that a Virtual Warehouse can concurrently process is determined by:
Choose 2 answers

Question53: Snowflake provides two mechanisms to reduce data storage costs for short-lived tables. These mechanisms are:
Choose 2 answers

Question54: True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

Question55: True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

Question56: True or False: Users are able to see the result sets of queries executed by other users that share their same role.